CREATE TABLE [dbo].[ContactEducation]
(
[ContactEducationKey] [uniqueidentifier] NOT NULL,
[ContactKey] [uniqueidentifier] NOT NULL,
[EducationLevelCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StartYear] [decimal] (4, 0) NULL,
[Specialty] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[School] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_ContactEducation_UpdatedOn] DEFAULT (getdate()),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[EndYear] [decimal] (4, 0) NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContactEducation] ADD CONSTRAINT [PK_ContactEducation] PRIMARY KEY CLUSTERED ([ContactEducationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactEducation_ContactKey] ON [dbo].[ContactEducation] ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactEducation_EducationLevelCode] ON [dbo].[ContactEducation] ([EducationLevelCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContactEducation_UpdatedByUserKey] ON [dbo].[ContactEducation] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactEducation] ADD CONSTRAINT [FK_ContactEducation_EducationRef] FOREIGN KEY ([EducationLevelCode]) REFERENCES [dbo].[EducationLevelRef] ([EducationLevelCode])
GO
ALTER TABLE [dbo].[ContactEducation] ADD CONSTRAINT [FK_ContactEducation_Individual] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[Individual] ([ContactKey])
GO
ALTER TABLE [dbo].[ContactEducation] ADD CONSTRAINT [FK_ContactEducation_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO